package com.systop.supervise.service;
import com.systop.common.pojo.performance;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PerformanceService {

    //1 添加
    int performanceadd(performance p);

    // 2通过tno查list
    List<performance> performancetno(String tno);

    //3通过成绩id 查list
    List<performance> performance_id_list(int performance_id);

    //3-1通过成绩id 查 实体
    performance performance_id_p(int performance_id);

    //3-2通过排课id查list
     List<performance> paikeId_tno(int elective_course_id);

    //4 通过成绩id修改
     int performanceUp(performance p);

    //5通过sno和排课id和状态
    List<performance> sno_pkid_allow(performance p);

   //6通过tno修改 发布成绩
    int allow_flagfabu(performance p);

    //5 查询所有
    @Select("select * from performance")
    List<performance> performanceall();
    //6通过id删除
    int performancedel(Integer performance_id);
}
